<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8"><meta charset="UTF-8"><title>teamwork_sql_explain</title>
<link href="./teamwork_sql_explain_files/bootstrap.css" rel="stylesheet">
</head>
<body>
	<div class="container">
	<h1 style="text-align:center;">teamwork 数据字典</h1>
	<h3>v5_admin管理员用户表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>userid</td>
						<td>用户ID</td>
						<td>rid</td>
						<td>角色ID</td>
						<td>username</td>
						<td>用户名</td>
					</tr>
					<tr>
						<td>nick</td>
						<td>用户昵称</td>
						<td>password</td>
						<td>密 码</td>
						<td>salt</td>
						<td>密码加盐</td>
					</tr>
					<tr>
						<td>logintime</td>
						<td>登录时间</td>
						<td>loginip</td>
						<td>登录IP</td>
						<td>status</td>
						<td>启用</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_cate后台栏目分类表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>cat_id</td>
						<td>栏目ID</td>
						<td>cat_name</td>
						<td>栏目名称</td>
						<td>parent_id</td>
						<td>父栏目ID</td>
					</tr>
					<tr>
						<td>tag_id</td>
						<td>关联模块ID</td>
						<td>paixu</td>
						<td>排列顺序</td>
						<td>addtime</td>
						<td>添加时间</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_companys 招聘公司表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>com_id</td>
						<td>公司id</td>
						<td>uid</td>
						<td>用户id</td>
						<td>comname</td>
						<td>公司名称</td>
					</tr>
					<tr>
						<td>com_sname</td>
						<td>公司简介</td>
						<td>com_logo</td>
						<td>公司logo</td>
						<td>com_url</td>
						<td>公司网址</td>
					</tr>
					<tr>
						<td>com_city</td>
						<td>公司所在地</td>
						<td>com_ly</td>
						<td>公司领域</td>
						<td>com_size</td>
						<td>公司规模</td>
					</tr>
					<tr>
						<td>com_sta</td>
						<td>公司融资状态</td>
						<td>com_sintro</td>
						<td>一句话介绍</td>
						<td>com_tag</td>
						<td>福利</td>
					</tr>
					<tr>
						<td>com_wenhua</td>
						<td>公司文化</td>
						<td>com_status</td>
						<td>公司认证状态</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_com_creater 公司创始人表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>cre_id</td>
						<td>创始人ID</td>
						<td>com_id</td>
						<td>公司ID</td>
						<td>cre_name</td>
						<td>创始人姓名</td>
					</tr>
					<tr>
						<td>cre_position</td>
						<td>创始人职务</td>
						<td>cre_weibo</td>
						<td>创始人微博</td>
						<td>cre_intro</td>
						<td>创始人介绍</td>
					</tr>
					<tr>
						<td>cre_img</td>
						<td>创始人照片</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_com_prod 公司产品表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>pro_id</td>
						<td>公司产品ID</td>
						<td>com_id</td>
						<td>关联公司ID</td>
						<td>prod_url</td>
						<td>产品网址</td>
					</tr>
					<tr>
						<td>prod_name</td>
						<td>产品名字</td>
						<td>prod_intro</td>
						<td>产品简介</td>
						<td>prod_img</td>
						<td>产品图片</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_com_rz 融资表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>rz_id</td>
						<td>融资公司ID</td>
						<td>com_id</td>
						<td>公司ID</td>
						<td>stage</td>
						<td>融资状态</td>
					</tr>
					<tr>
						<td>org</td>
						<td>融资公司名字</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_eduexp 学历表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>eid</td>
						<td>学历ID</td>
						<td>pid</td>
						<td>简历ID</td>
						<td>uid</td>
						<td>求职者ID</td>
					</tr>
					<tr>
						<td>school</td>
						<td>学校名称</td>
						<td>edulv</td>
						<td>学历</td>
						<td>excuname</td>
						<td>专业名称</td>
					</tr>
					<tr>
						<td>startyear</td>
						<td>开始时间</td>
						<td>endyear</td>
						<td>结束时间</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_friendlink 友情链接表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>fid</td>
						<td>主键</td>
						<td>uid</td>
						<td>关联用户ID</td>
						<td>title</td>
						<td>标题</td>
					</tr>
					<tr>
						<td>number</td>
						<td>编号</td>
						<td>links</td>
						<td>url地址</td>
						<td>describe</td>
						<td>描述</td>
					</tr>
					<tr>
						<td>release</td>
						<td>发布</td>
						<td>norel</td>
						<td>不发布</td>
					</tr>	
				</tbody>
		</table>
	<h3>v5_jobs表 职业表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>job_id</td>
						<td>发布职位ID</td>
						<td>com_id</td>
						<td>公司ID</td>
						<td>positiontype</td>
						<td>职位类型</td>
					</tr>
					<tr>
						<td>positionname</td>
						<td>职位名称</td>
						<td>department</td>
						<td>所属部门</td>
						<td>jobnature</td>
						<td>全职|兼职</td>
					</tr>
					<tr>
						<td>salarymin</td>
						<td>最低薪资(k)</td>
						<td>salarymax</td>
						<td>最高薪资</td>
						<td>workyear</td>
						<td>需要的工作经验</td>
					</tr>
					<tr>
						<td>education</td>
						<td>需要的学历</td>
						<td>positonadvantage</td>
						<td>职位待遇</td>
						<td>positionaddress</td>
						<td>工作地点</td>
					</tr>
					<tr>
						<td>positionlng</td>
						<td>职位描述</td>
						<td>email</td>
						<td>接受简历邮箱</td>
						<td>forwardemail</td>
						<td>自动发送简历邮箱</td>
					</tr>
					<tr>
						<td>pubtime</td>
						<td>发布时间</td>
						<td>is_hot</td>
						<td>0非热门 1热门</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_opus 简历中作品表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>opu_id</td>
						<td>作品ID自增</td>
						<td>pid</td>
						<td>简历ID</td>
						<td>uid</td>
						<td>求职者ID</td>
					</tr>
					<tr>
						<td>pro_link</td>
						<td>作品链接</td>
						<td>pro_prointro</td>
						<td>作品介绍</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_postresumes 求职者的简历表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>pid</td>
						<td>自增简历ID</td>
						<td>uid</td>
						<td>求职者ID</td>
						<td>job_id</td>
						<td>职位ID</td>
					</tr>
					<tr>
						<td>name</td>
						<td>求职者姓名</td>
						<td>tel</td>
						<td>求职者电话</td>
						<td>email</td>
						<td>求职者邮箱</td>
					</tr>
					<tr>
						<td>gender</td>
						<td>求职者性别</td>
						<td>birthday</td>
						<td>求职者生日</td>
						<td>job_life</td>
						<td>工作年限</td>
					</tr>
					<tr>
						<td>now_place</td>
						<td>现居住地</td>
						<td>education</td>
						<td>教育程度</td>
						<td>job_status</td>
						<td>工作状态</td>
					</tr>
					<tr>
						<td>job_type</td>
						<td>全职|兼职</td>
						<td>origin_place</td>
						<td>出生地</td>
						<td>job_name</td>
						<td>职位名称</td>
					</tr>
					<tr>
						<td>wish_city</td>
						<td>期望工作的城市</td>
						<td>wish_job</td>
						<td>期望的工作</td>
						<td>wish_pay</td>
						<td>期望薪资</td>
					</tr>
					<tr>
						<td>self_introduce</td>
						<td>自我介绍</td>
						<td>pubtime</td>
						<td>发布时间</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_proexp 简历中项目表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>pe_id</td>
						<td>项目ID</td>
						<td>pid</td>
						<td>简历ID</td>
						<td>uid</td>
						<td>求职者ID</td>
					</tr>
					<tr>
						<td>xmmc</td>
						<td>项目名称</td>
						<td>position</td>
						<td>担任职位</td>
						<td>startyear</td>
						<td>起止日期</td>
					</tr>
					<tr>
						<td>startmonth</td>
						<td></td>
						<td>endyear</td>
						<td></td>
						<td>endmonth</td>
						<td></td>
					</tr>
					<tr>
						<td>xmms</td>
						<td>项目描述</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_recruits 公司发布岗位招聘表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>reid</td>
						<td>自增岗位ID</td>
						<td>com_id</td>
						<td>公司ID</td>
						<td>comname</td>
						<td>公司名称</td>
					</tr>
					<tr>
						<td>job_id</td>
						<td>职位ID</td>
						<td>job_name</td>
						<td>职位名称</td>
						<td>req_people</td>
						<td>需求人数</td>
					</tr>
					<tr>
						<td>req_education</td>
						<td>学历要求</td>
						<td>req_worktime</td>
						<td>工作经验要求</td>
						<td>salary</td>
						<td>工作薪资</td>
					</tr>
					<tr>
						<td>pubtime</td>
						<td>发布时间</td>
					</tr>
				</tbody>
		</table>
    <h3>v5_resumes 求职者个人简历表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>rid</td>
						<td>自增ID</td>
						<td>uid</td>
						<td>求职者ID</td>
						<td>name</td>
						<td>姓名</td>
					</tr>
					<tr>
						<td>sex</td>
						<td>性别</td>
						<td>age</td>
						<td>年龄</td>
						<td>education</td>
						<td>学历</td>
					</tr>
					<tr>
						<td>mobile</td>
						<td>手机号</td>
						<td>expectedjob</td>
						<td>期望学历</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_resumes_post  简历投递历史记录</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>rid</td>
						<td>主键自增ID</td>
						<td>uid</td>
						<td>关联的求职者ID</td>
						<td>pid</td>
						<td>关联简历ID</td>
					</tr>
					<tr>
						<td>com_id</td>
						<td>关联投递的公司ID</td>
						<td>job_id</td>
						<td>投递的职位ID</td>
						<td>positionname</td>
						<td>投递的职位名称 冗余字段</td>
					</tr>
					<tr>
						<td>status</td>
						<td>投递状态 0待查看 1查看未通过 2查看已通过</td>
						<td>posttime</td>
						<td>投递时间</td>
						<td>updatetime</td>
						<td>投递简历更新时间</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_role 角色表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>rid</td>
						<td>角色ID</td>
						<td>rname</td>
						<td>角色名</td>
						<td>rnick</td>
						<td>角色昵称</td>
					</tr>
					<tr>
						<td>rstatus</td>
						<td>角色状态</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_setting 网站基本设置表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>item_id</td>
						<td>主键自增</td>
					</tr>
					<tr>
						<td>itemkey</td>
						<td>键名</td>
						<td>itemvalue</td>
						<td>键值</td>
						<td>item</td>
						<td>模块ID</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_users 用户表.注册用户的表.求职者和企业用户表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>uid</td>
						<td>用户ID</td>
						<td>nick</td>
						<td>昵称</td>
						<td>mobile</td>
						<td>手机号</td>
					</tr>
					<tr>
						<td>email</td>
						<td>邮箱</td>
						<td>password</td>
						<td>密码</td>
						<td>acctype</td>
						<td>用户类型 0求职者 1企业用户</td>
					</tr>
					<tr>
						<td>accstatus</td>
						<td>用户状态 0未审核 1审核通过</td>
						<td>regtime</td>
						<td>注册时间</td>
						<td>logintime</td>
						<td>登录时间</td>
					</tr>
				</tbody>
		</table>
	<h3>v5_workexp 工作经验表</h3>
		<table class="table table-hover table-bordered table-condensed">
			<thead>
			<tr>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
				<th>字段名</th>
				<th>备注</th>
			</tr>
			</thead>
				<tbody>
					<tr>
						<td>wid</td>
						<td>主键自增</td>
						<td>uid</td>
						<td>求职者ID</td>
						<td>pid</td>
						<td></td>
					</tr>
					<tr>
						<td>companyname</td>
						<td>公司名称</td>
						<td>cargo</td>
						<td>职位名称</td>
						<td>startyear</td>
						<td>起止日期</td>
					</tr>
					<tr>
						<td>startmonth</td>
						<td></td>
						<td>endyear</td>
						<td></td>
						<td>endmonth</td>
						<td></td>
					</tr>
				</tbody>
		</table>

	</div>
</body>
</html>